Mega Code Archive
System Packages
1) A PLSQL block to read an operating system file called BLOB JPG that contains 1 row of binary data
2) Add our policy to the EMP view
3) An example of using DBMS_SQL OPEN_CURSOR
4) Artificial delay with the DBMS_LOCK SLEEP procedure
5) Assign date with DBMS_SQL package
6) Assign value from dbms_utility get_time to a number variable
7) Avg # RowsBlock
8) Build query form with HTP
9) Call DBMS_ALERT SIGNAL in a trigger
10) Call dbms_alert signal in a loop
11) Call dbms_profiler start_profiler to start profiler
12) Call dbms_rls add_policy to add policy to a table with statement type, update check and function schema
13) Call dbms_utility analyze_schema analyze schema
14) Call dbms_utility db_version to get the version and its compatible version
15) Call dbms_utility get_parameter_value to get the value of utl_file_dir
16) Call dbms_utility get_time twice
17) Call dbms_utility get_time twice to time the insert statement
18) Call substr in DBMS_OUTPUT PUT_LINE
19) Capture DBMS_PROFILER information for the specified script
20) Check table status with SYS DBMS_STATS gather_table_stats after adding index
21) Close a cursor
22) Conditional Compilation
23) Create (anonymous) transient type with two attributes
24) Create a procedure to collect statistics on all my objects
25) Create HTML List tags
26) Create PlSQL block dynamically and then execute it by calling DBMS_SQL EXECUTE
27) DBMS_ALERT REGISTER
28) Dbms_alert waitone
29) DBMS_APPLICATION_INFO SET_MODULE
30) Dbms_application_info set_client_info
31) Dbms_application_info set_client_info and dbms_application_info set_action
32) Dbms_application_info set_client_info to change client information
33) DBMS_AQ ENQUEUE_OPTIONS_T
34) Dbms_aqadm create_queue_table
35) DBMS_AQADM STOP_QUEUE
36) Dbms_crypto ENCRYPT_AES128
37) DBMS_CRYPTO encrypt_aes128 + DBMS_CRYPTO chain_cbc + DBMS_CRYPTO pad_pkcs5
38) Dbms_crypto hash
39) Dbms_crypto hash_sh1
40) Dbms_crypto mac
41) Dbms_crypto randombytes
42) DBMS_DEBUG probe_version
43) Dbms_fga add_policy
44) Dbms_java grant_permission
45) DBMS_JOB demonstration
46) DBMS_JOB SUBMIT
47) DBMS_LOB Package
48) DBMS_LOB READ
49) Dbms_lock sleep
50) Dbms_logmnr add_logfile
51) Dbms_metadata get_ddl( TABLE, TABLENAME )
52) Dbms_metadata get_xml
53) Dbms_obfuscation_toolkit DES3Decrypt
54) Dbms_obfuscation_toolkit DES3GETKEY and dbms_obfuscation_toolkit DES3ENCRYPT
55) DBMS_OUTPUT CHARARR
56) Dbms_output new_line
57) DBMS_PIPE CREATE_PIPE
58) DBMS_PIPE PACK_MESSAGE
59) DBMS_PIPE RECEIVE_MESSAGE
60) DBMS_PIPE RECEIVE_MESSAGE with timeout
61) DBMS_PIPE REMOVE_PIPE
62) DBMS_PIPE RESET_BUFFER
63) DBMS_PIPE SEND_MESSAGE
64) DBMS_PIPE SEND_MESSAGE with timeout
65) DBMS_PIPE UNPACK_MESSAGE and record type
66) Dbms_preprocessor print_post_processed_source
67) DBMS_PROFILER get_version
68) Dbms_profiler start_profiler
69) DBMS_RANDOM INITIALIZE and DBMS_RANDOM RANDOM
70) DBMS_RANDOM RANDOM()
71) Dbms_rls drop_policy
72) Dbms_rls drop_policy and dbms_rls add_policy
73) Dbms_rls shared_static
74) DBMS_ROWID ROWID_BLOCK_NUMBER and DBMS_ROWID ROWID_ROW_NUMBER
75) DBMS_ROWID ROWID_RELATIVE_FNO(RowID)
76) DBMS_ROWID ROWID_RELATIVE_FNO(RowID),DBMS_ROWID ROWID_BLOCK_NUMBER(RowID)
77) DBMS_ROWID ROWID_ROW_NUMBER(RowID)
78) DBMS_ROWID ROWID_TO_RESTRICTED
79) DBMS_ROWID ROWID_TO_RESTRICTED(RowID,0)
80) DBMS_SESSION IS_ROLE_ENABLED
81) DBMS_SESSION SET_SQL_TRACE
82) Dbms_session set_context
83) DBMS_SQL BIND_VARIABLE and DBMS_SQL EXECUTE
84) DBMS_SQL EXECUTE an update statement
85) DBMS_SQL LAST_ERROR_POSITION
86) Dbms_sql number_table
87) DBMS_SQL PARSE
88) DBMS_SQL VARCHAR2_TABLE and DBMS_SQL NUMBER_TABLE
89) Dbms_stats drop_stat_table, dbms_stats create_stat_table,dbms_stats delete_system_stats
90) Dbms_stats gather_schema_stats
91) Dbms_stats gather_table_stats
92) Dbms_stats import_system_stats
93) Dbms_stats objectTab
94) Dbms_stats set_table_stats( user, EMP, numrows = 100000 )
95) Dbms_stats set_table_stats( user, myTable1, numrows = 10000000, numblks = 1000000 )
96) DBMS_TRANSACTION USE_ROLLBACK_SEGMENT
97) DBMS_UTILITY FORMAT_CALL_STACK and DBMS_UTILITY FORMAT_ERROR_STACK
98) Dbms_utility format_error_stack
99) Dbms_utility get_hash_value
100) Dbms_wm EnableVersioning
101) Dbms_xmlschema registerSchema
102) Demonstrate DBMS_PROFILER
103) Demonstrate DES3 encryption
104) Desc v$session_longops
105) Difference between utl_raw length and length
106) Display employee in HTML format using HTP package
107) Display records in a HTML table
108) Display records in a HTML table with parameters
109) Display table names in user_tables in HTML format with HTP PRINT
110) Distinct Blocks
111) Dump Column long with DBMS_SQL DEFINE_COLUMN_LONG
112) Dump query with dbms_sql
113) EXECUTE DBMS_OUTPUT ENABLE(10000)
114) Execute SYS DBMS_STATS gather_table_stats(USER, employee_job)
115) Execute the query on the specified columns and table
116) File open and close with UTL_FILE package
117) File open flags
118) Get a line from a file with UTL_FILE package
119) HTP PRINT with to_char method
120) Job number
121) Load a file
122) Max # RowsBlock
123) Min # RowsBLock
124) Open a file with mode passed in
125) Open the output file for writing
126) Output a form with action
127) Output a html table
128) Output character or line
129) Output employee name with plsql, cursor and dbms_output put_line
130) Output varchar variable
131) Output Visual line break
132) Package for running dynamic sql based on DBMS_SQL package
133) Print clob data out
134) Print table with dynamic query
135) Profiler for recursive function
136) Q for quotation with []
137) Query system_privilege_map
138) Read Changed Values and Display
139) Read file
140) Read from the CLOB in chunks of 1000 characters and write to the output file
141) Read Original Values and Display
142) Registers the alert for the session
143) Save lines to a file
144) Save string to a file with UTL_FILE PUTF
145) Save table records to a file
146) Schedule the procedure to run now and every night at 3 AM
147) Select utl_raw cast_to_varchar2(hextoraw(534d495448)) from dual
148) Select utl_raw cast_to_varchar2(hextoraw(787878)) from dual
149) Send email
150) Send out email with utl_smtp
151) Show file content
152) Show Java source file
153) Show table space
154) Signal along with the entries in a table
155) Singal with dbms_alert signal
156) Submit a job and query the user_jobs
157) Submit a job and run
158) Submit job to change password
159) Sys dbms_logmnr add_logfile
160) Sys dbms_logmnr start_logmnr
161) Sys dbms_logmnr_d build
162) Timing log
163) Use a character string of arithmetic logic, selecting against the DUAL table to return a number value
164) Use dbms_job submit to call execute immediate
165) Use dbms_lob getlength and dbms_lob substr with blob type column
166) Use dbms_lob getlength to get the length of a clob data
167) Use dbms_lob package to deal with clob data
168) Use dbms_lob substr to get part of clob data
169) Use DBMS_OUTPUT PUT_LINE to output clob data
170) Use DBMS_OUTPUT PUT_LINE to output the table collection indexed by BINARY_INTEGER
171) Use DBMS_PIPE to pack message and send message
172) Use dbms_pipe package
173) Use DBMS_PROFILER to compare the performance differences between row-at-a-time processing and bulk processing
174) Use dbms_rowid rowid_block_number
175) Use dbms_session AppCtxTabTyp and dbms_session list_context to display context
176) Use dbms_space free_blocks and dbms_space unused_space
177) Use dbms_sql describe_columns
178) Use DBMS_SQL package to parse math expression
179) Use DBMS_SQL to update a table and get the number of rows updated
180) Use dbms_utility comma_to_table, dbms_utility table_to_comma to parse comma delimited value
181) Use dbms_utility name_resolve to find a package
182) Use dbms_utility name_tokenize to split a name
183) Use dynamic SQL to check the business logic
184) Use HTP package to create HTML page structure
185) Use UTL_FILE package to create a file
186) Use utl_raw cast_to_raw to convert string to raw
187) Use utl_raw substr
188) Use utl_tcp package to load web pages
189) Uses DBMS_DDL CREATE_WRAPPED to obfuscate PLSQL source
190) Using HTP PRINT and HTF BR to output a HTML
191) UTL_FILE IS_OPEN
192) Utl_file invalid_&&firstparm
193) UTL_File related exception
194) Utl_i18n string_to_raw and dbms_crypto encrypt
195) Utl_raw cast_to_raw
196) View the post-processed source
197) Wrap dbms_sql package
198) Write text to a file with UTL_FILE package